#! /bash/bin
db_name=fujunhua
hive -e "
use $db_name;
create table app_abstract_info(
appid string comment 'appId',
name string comment '名称',
classify1 string comment '一级分类',
classify2 string comment '二级分类',
classify3 string comment '三级分类',
tags string comment '标签'
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n'
STORED AS textfile;
"
